Application of data warehouse technology in power analysis

Data warehouse technology transforms the operational data store to general and compositive information. It also provides effective way for analysis and statistic to the mass data, and helps to do the decision-making. The paper introduces the data warehouse and the online analysis process. According to the power management information system, the paper analyzes the power-oriented multidimensional database modeling and the presentation of multidimensional views. The system also builds power-oriented data warehouse using DB2 database, Warehouse Manager, Cube View and Alphablox of IBM. Then, this paper discusses the concrete applications of data warehouse in completing the extract, transform and load (ETL) of power data. The discussion includes the optimization of the system after creating the MQT tables using Cube View and the presentation of the analysis system. The system can help power corporations to do the decision-making.